package org.jeecg.modules.bank.mapper;

import java.util.List;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.bank.entity.YcYingshengBank;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.modules.gongqiang.entity.Userhome;
import org.jeecg.modules.gongqiang.entity.YcYingshengUserwallt;

/**
 * @Description: 银盛银行卡信息
 * @Author: jeecg-boot
 * @Date:   2024-08-25
 * @Version: V1.0
 */
@DS("yungcang")
public interface YcYingshengBankMapper extends BaseMapper<YcYingshengBank> {
    @Select("select * from yc_yingsheng_bank where account_name=#{accountName} and bank_number=#{bankNumber} and is_can_protocol=0 and status=1")
    YcYingshengBank findBank(@Param("accountName") String accountName, @Param("bankNumber") String bankNumber);

    @Select("select * from yc_yingsheng_bank where id=#{id} and status=1")
    YcYingshengBank findBankByid(@Param("id") Integer id);





}
